create external  table jms_dim.dim_tab_order_pick_rate_setting_base_dt
(
  ID                 int comment 'id',
  SPECIAL_LIMITATION int comment '特殊时期揽收时效',
  START_TIME         TIMESTAMP comment '开始时间',
  END_TIME           TIMESTAMP comment '结束时间',
  UPDATE_TIME        TIMESTAMP comment '更新时间'
)comment '及时揽收率配置-特殊时效'
 PARTITIONED BY (
  `dt` string COMMENT '时间分区')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_dim.db/external/dim_tab_order_pick_rate_setting_base_dt';